{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["BARCODE","RECORD","DATABASE"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"row_number_cap","date_system":"1900"}

{"sheet":"BARCODE","index":0,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,1,1,4],[2,0,2,4],[3,0,3,4],[14,0,14,4],[10,0,10,2],[11,0,11,2],[12,0,13,2],[8,1,8,2],[9,1,9,2],[8,9,9,9],[4,0,5,3],[6,0,7,1],[4,7,5,7],[16,6,18,7],[8,7,9,7]],"read":"row_number_cap"}
[{"$f":"INDEX(DATABASE!A2:A4,F1)","v":"REDBEEF"},null,null,"#",1,2,null,null,null,null,null,"warna kuning itu adalah qty Kilogram, saya akan menggantinya tiap mau dicetak"]
["Prod By :",{"$f":"IF(A1=\"\",\"\",VLOOKUP(A1,DATABASE!$A$2:$D$4,2,0))","v":"PT. CIANJUR ARTA MAKMUR"},null,null,null,12,null,null,null,null,null,"pertanyaanya bisakah saya isi data kilogramnya sekaligus banyak tapi untuk item code"]
["Jl. Raya Cileungsi - Jonggol KM 06 No 04 Ds. Gandoang Kec. Cileungsi",null,null,null,null,55,null,null,null,null,null,"dan lain-lain masih mengikuti data yang ada, misal langsung 10 qty atau terbatas "]
["Tlp. 021- 2909685 Fax 021-2909687 admcamcil@gmail.com",null,null,null,null,{"$f":"IF(J9=\"\",\"\",IF(D14=\"KEEP\",\"-Pcs\",D14))","v":"-Pcs"}]
[{"$f":"INDEX(DATABASE!E2:E122,F2)","v":"BRISKET NE"},null,null,null,{"$f":"INDEX(DATABASE!F2:F106,F3)","v":"GH70"},null,null,null,null,null,null,"12.23","21.12","55.1","15.23","14.26","17.30"]
[]
[{"$f":"H9","v":20},null,{"$f":"CONCATENATE(J9,F4)","v":"5-Pcs"}]
[]
["Packed  :","2017-05-19",null,null,null,null,null,20,"Pcs",5,null,"dari contoh diatas yang tercetak hanya yang terisi data"]
["Expired :","2017-05-27",null,null,null,null,null,null,"Kg",null,null,"terimakasih"]
[{"$f":"IF(A1=\"\",\"\",VLOOKUP(A1,DATABASE!$A$2:$D$4,3,0))","v":"LPOM MUI-JB01014001431214"}]
[{"$f":"IF(A1=\"\",\"\",VLOOKUP(A1,DATABASE!$A$2:$D$4,4,0))","v":"NKV RPH-32011702"},null,null,null,null,null,null,null,null,null,null,"Nb. Untuk qr ini memakai koneksi internet tapi lemot sekali yah"]
[]
[null,null,null,"KEEP",{"$f":"IF(E5=\"\",\"\",VLOOKUP(E5,DATABASE!$F$2:$G$106,2,0))","v":"FROZEN"}]
[{"$f":"CONCATENATE(E5,\" \",A5,\" \",A7,\"Kg\",\" \",C7,\" \",\"CLS\")","v":"GH70 BRISKET NE 20Kg 5-Pcs CLS"}]
[null,{"$f":"IF(A16=\"\",\"\",IF(D14=\"KEEP\",\"-PCS\",A8))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"GH70 BRISKET NE 20Kg 5-Pcs CLS"]

{"sheet":"RECORD","index":1,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["#NO","KODE","ITEM","QTY"]
[1,"GH70","BRISKET NE",20]
[]
[]
[]
[]
[]
[{"$f":"IF(B8=\"\",\"\",IF(A7=\"NO\",1,A7+1))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]

{"sheet":"DATABASE","index":2,"n_rows":127,"n_cols":7,"rows_kept":127,"cut":false,"hidden":true,"merged":[]}
["BRAND","KETERANGAN","BPPOM","NKV","ITEM","KODE","JENIS"]
["CHOICE","PT. SINAR DAGING PERDANA","LPOM MUI-JB01014001431214","NKV RPH-32011702","BABAT","AL05","FROZEN"]
["REDBEEF","PT. CIANJUR ARTA MAKMUR","LPOM MUI-JB01014001431214","NKV RPH-32011702","BACK BONE","AL11","FROZEN"]
["BEEFFOOD","PT. BEEFFOOD INDONESIA","LPOM MUI ID 1024003270812","NKV RPH-320118-031","BACKRIB","AL16","FROZEN"]
[null,null,null,null,"BLADE","AL31","FROZEN"]
[null,null,null,null,"BLADE CUT","AL41","FROZEN"]
[null,null,null,null,"BLADE ROSTER","AL42","FROZEN"]
[null,null,null,null,"BONE","AL44","FROZEN"]
[null,null,null,null,"BONE SP","AL45","FROZEN"]
[null,null,null,null,"BOOL","AL46","FROZEN"]
[null,null,null,null,"BRISKET","AL64","FROZEN"]
[null,null,null,null,"BRISKET BONE","AL65","FROZEN"]
[null,null,null,null,"BRISKET NE","AL67","FROZEN"]
[null,null,null,null,"BRISKET PE","AM06","FROZEN"]
[null,null,null,null,"CHEEK MEAT","AM11","FROZEN"]
[null,null,null,null,"CHUCK","AM18","FROZEN"]
[null,null,null,null,"CHUCKROLL","AM31","FROZEN"]
[null,null,null,null,"CHUCKTENDER","AM41","FROZEN"]
[null,null,null,null,"CINGUR","AM42","FROZEN"]
[null,null,null,null,"CONRO","AM44","FROZEN"]
[null,null,null,null,"CONRO MIX","AM45","FROZEN"]
[null,null,null,null,"CONRO SQUARE","AM46","FROZEN"]
[null,null,null,null,"CRESHMEAT","AM64","FROZEN"]
[null,null,null,null,"CUBEROLL","AM65","FROZEN"]
[null,null,null,null,"CUBEROLL AGED","AM67","FROZEN"]
[null,null,null,null,"DAGING KEPALA","BCLA","CHILL"]
[null,null,null,null,"DAGING PAKET","BFLA","FROZEN"]
[null,null,null,null,"DAGING PIPI","BFLB","FROZEN"]
[null,null,null,null,"D-RUMP","BFLR","FROZEN"]
[null,null,null,null,"FAT BONING","BG06","FROZEN"]
[null,null,null,null,"FAT TRIMMING","BG11","FROZEN"]
[null,null,null,null,"FLANK STEAK","BG18","FROZEN"]
[null,null,null,null,"FQ 65 CL","BG31","FROZEN"]
[null,null,null,null,"FQ 70 VL FTM","BG41","FROZEN"]
[null,null,null,null,"FQ 75 VL","BG42","FROZEN"]
[null,null,null,null,"FQ 85 CL","BG44","FROZEN"]
[null,null,null,null,"FQ 90 CL","BG45","FROZEN"]
[null,null,null,null,"FQ 95 BALL","BG46","FROZEN"]
[null,null,null,null,"FQ 95 IW","BG64","FROZEN"]
[null,null,null,null,"FQ 95 VL","BG65","FROZEN"]
[null,null,null,null,"FRENCHES","BG67","FROZEN"]
[null,null,null,null,"FULL RIB","BK35","FROZEN"]
[null,null,null,null,"FULL SILVERSIDE","BPKG","FROZEN"]
[null,null,null,null,"GANDIK","CCIA","CHILL"]
[null,null,null,null,"GINJAL","CCLA","CHILL"]
[null,null,null,null,"HANGING TENDER","CFIA","FROZEN"]
[null,null,null,null,"HEAD","CFIB","FROZEN"]
[null,null,null,null,"JANTUNG","CFIR","FROZEN"]
[null,null,null,null,"KAKI","CFLA","FROZEN"]
[null,null,null,null,"KEMBANG WARU","CFLB","FROZEN"]
[null,null,null,null,"KEPALA UTUH","CFLR","FROZEN"]
[null,null,null,null,"KNUCKLE","FH35","FROZEN"]
[null,null,null,null,"KULIT","FU35","FROZEN"]
[null,null,null,null,"KULIT KEPALA","GH14","FROZEN"]
[null,null,null,null,"LEMAK GINJAL","GH35","FROZEN"]
[null,null,null,null,"LEMAK PERUT","GH70","FROZEN"]
[null,null,null,null,"LEMAK SUSU","GT35","FROZEN"]
[null,null,null,null,"LIDAH","GU14","FROZEN"]
[null,null,null,null,"LIMFA","GU35","FROZEN"]
[null,null,null,null,"LIPS","GU70","FROZEN"]
[null,null,null,null,"LIVER","KB06","FROZEN"]
[null,null,null,null,"LIVER NOLAN","KB11","FROZEN"]
[null,null,null,null,"LUNG","KB18","FROZEN"]
[null,null,null,null,"MARROW BONE","KB31","FROZEN"]
[null,null,null,null,"MARROW BONE SP","KB41","FROZEN"]
[null,null,null,null,"MATA","KB42","FROZEN"]
[null,null,null,null,"MBT","KB44","FROZEN"]
[null,null,null,null,"MINCE BEEF 85 CL","KB45","FROZEN"]
[null,null,null,null,"MINCE BEEF 90 CL","KB46","FROZEN"]
[null,null,null,null,"NECKBONE","KB64","FROZEN"]
[null,null,null,null,"NECKBONE SP","KB65","FROZEN"]
[null,null,null,null,"OFFAL","KB67","FROZEN"]
[null,null,null,null,"OPERIB","MK06","FROZEN"]
[null,null,null,null,"OSSO BOCCO","MK11","FROZEN"]
[null,null,null,null,"OUTSIDE","MK18","FROZEN"]
[null,null,null,null,"OUTSIDE FLAT","MK31","FROZEN"]
[null,null,null,null,"OXTAIL CENTER CUT","MK41","FROZEN"]
[null,null,null,null,"OXTAIL MEDIUM","MK42","FROZEN"]
[null,null,null,null,"OXTAIL SMALL","MK44","FROZEN"]
[null,null,null,null,"OXTAIL WHL","MK45","FROZEN"]
[null,null,null,null,"PRIMERIB","MK46","FROZEN"]
[null,null,null,null,"RIB FINGER","MK64","FROZEN"]
[null,null,null,null,"RUMP","MK65","FROZEN"]
[null,null,null,null,"RUMP KTH","MK67","FROZEN"]
[null,null,null,null,"SCAPULAR","PS35","FROZEN"]
[null,null,null,null,"SHANK","RCLA","CHILL"]
[null,null,null,null,"SHORTLOIN","RFLA","FROZEN"]
[null,null,null,null,"SHORTPLATE Y","RFLB","FROZEN"]
[null,null,null,null,"SHORTRIB","RFLR","FROZEN"]
[null,null,null,null,"SILVERSIDE","SS80","FROZEN"]
[null,null,null,null,"SODAS","TCLA","CHILL"]
[null,null,null,null,"SPARERIB","TFLA","FROZEN"]
[null,null,null,null,"STRIPLOIN","TFLB","FROZEN"]
[null,null,null,null,"STRIPLOIN AGED","TFLR","FROZEN"]
[null,null,null,null,"STRIPLOIN CUT","TM06","FROZEN"]
[null,null,null,null,"SUKIYAKI","TM11","FROZEN"]
[null,null,null,null,"SWEET BREAD","TM18","FROZEN"]
[null,null,null,null,"T BONE","TM31","FROZEN"]
[null,null,null,null,"TAILTOP","TM41","FROZEN"]
[null,null,null,null,"TENDERLOIN","TM42","FROZEN"]
[null,null,null,null,"TENDERLOIN AGED","TM44","FROZEN"]
[null,null,null,null,"TENDERLOIN BUTT","TM45","FROZEN"]
[null,null,null,null,"TENDON","TM46","FROZEN"]
[null,null,null,null,"TENDON SP","TM64","FROZEN"]
[null,null,null,null,"TENGGOROKAN","TM65","FROZEN"]
[null,null,null,null,"TESTIS","TM67","FROZEN"]
[null,null,null,null,"THIN FLANK"]
[null,null,null,null,"TOMOWHAWK"]
[null,null,null,null,"TOMOWHAWK CUT"]
[null,null,null,null,"TOPSIDE"]
[null,null,null,null,"TOUNGE ROOT"]
[null,null,null,null,"TRIMCUBE"]
[null,null,null,null,"TULANG KEPALA"]
[null,null,null,null,"TULANG TELINGA"]
[null,null,null,null,"USUS"]
[null,null,null,null,"UTER"]
[null,null,null,null,"NEW ITEM"]
[null,null,null,null,"NEW ITEM"]
[null,null,null,null,"NEW ITEM"]
[null,null,null,null,"NEW ITEM"]
[null,null,null,null,"NEW ITEM"]
[null,null,null,null,"NEW ITEM"]
[null,null,null,null,"NEW ITEM"]
[null,null,null,null,"NEW ITEM"]
[null,null,null,null,"NEW ITEM"]
[null,null,null,null,"NEW ITEM"]
[null,null,null,null,"NEW ITEM"]